create or replace view vac_application_substit_4_1 as
with ap_s as
(
select
 workspace,
 workspace_display_name,
 application_id,
 application_name,
 substitution_string,
 substitution_value
from APEX_APPLICATION_SUBSTITUTIONS
)
select
 workspace,
 workspace_display_name,
 application_id,
 application_name,
 substitution_string,
 u_value,
 u_name,
 'APEX_APPLICATION_SUBSTITUTIONS' src_view_name
 from ap_s UNPIVOT INCLUDE NULLS
  (u_value FOR u_name IN
   (
    substitution_value
   )
  );

